Tweet
Bonjour à tous,
Après avoir installé une copie de mon site en local (wamp) et supprimé absolument toutes mes extension (template, composant...), j'ai un message d'erreur à la fin de la mise à jour (voir ci-dessous). Le site et ma base de donnée sont pourtant bien à jour (2.5.28). Après cette erreur l'administration du site est inutilisable car chaque lien mène vers une page blanche Quelqu'un aurait une idée ?
1062 - Une erreur s'est produite
Duplicate entry '1' for key 'PRIMARY' SQL=-- -- Dumping data for table `gftg0_content_types` -- INSERT INTO `gftg0_content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`,`router`) VALUES (1, 'Article', 'com_content.article', '{"special":{"dbtable":"#__content","key":"id","ty pe":"Content","prefix":"JTable","config":"array()" },"common":{"dbtable":"#__core_content","key":"ucm _id","type":"Corecontent","prefix":"JTable","confi g":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"state","core_alias":"alias","core_cr eated_time":"created","core_modified_time":"modifi ed","core_body":"introtext", "core_hits":"hits","core_publish_up":"publish_up", "core_publish_down":"publish_down","core_access":" access", "core_params":"attribs", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"asset_id"}], "special": [{"fulltext":"fulltext"}]}','ContentHelperRoute::getArticleRoute'), (2, 'Contact', 'com_contact.contact', '{"special":{"dbtable":"#__contact_details","key": "id","type":"Contact","prefix":"ContactTable","con fig":"array()"},"common":{"dbtable":"#__core_conte nt","key":"ucm_id","type":"Corecontent","prefix":" JTable","config":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"name"," core_state":"published","core_alias":"alias","core _created_time":"created","core_modified_time":"mod ified","core_body":"address", "core_hits":"hits","core_publish_up":"publish_up", "core_publish_down":"publish_down","core_access":" access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"image", "core_urls":"webpage", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}], "special": [{"con_position":"con_position","suburb":"suburb"," state":"state","country":"country","postcode":"pos tcode","telephone":"telephone","fax":"fax","misc": "misc","email_to":"email_to","default_con":"defaul t_con","user_id":"user_id","mobile":"mobile","sort name1":"sortname1","sortname2":"sortname2","sortna me3":"sortname3"}]}','ContactHelperRoute::getContactRoute'), (3, 'Newsfeed', 'com_newsfeeds.newsfeed', '{"special":{"dbtable":"#__newsfeeds","key":"id"," type":"Newsfeed","prefix":"NewsfeedsTable","config ":"array()"},"common":{"dbtable":"#__core_content" ,"key":"ucm_id","type":"Corecontent","prefix":"JTa ble","config":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"name"," core_state":"published","core_alias":"alias","core _created_time":"created","core_modified_time":"mod ified","core_body":"description", "core_hits":"hits","core_publish_up":"publish_up", "core_publish_down":"publish_down","core_access":" access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}], "special": [{"numarticles":"numarticles","cache_time":"cache_t ime","rtl":"rtl"}]}','NewsfeedsHelperRoute::getNewsfeedRoute'), (4, 'User', 'com_users.user', '{"special":{"dbtable":"#__users","key":"id","type ":"User","prefix":"JTable","config":"array()"},"co mmon":{"dbtable":"#__core_content","key":"ucm_id", "type":"Corecontent","prefix":"JTable","config":"a rray()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"name"," core_state":"null","core_alias":"username","core_c reated_time":"registerdate","core_modified_time":" lastvisitDate","core_body":"null", "core_hits":"null","core_publish_up":"null","core_ publish_down":"null","access":"null", "core_params":"params", "core_featured":"null", "core_metadata":"null", "core_language":"null", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"null", "core_metakey":"null", "core_metadesc":"null", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}], "special": [{}]}','UsersHelperRoute::getUserRoute'), (5, 'Article Category', 'com_content.category', '{"special":{"dbtable":"#__categories","key":"id", "type":"Category","prefix":"JTable","config":"arra y()"},"common":{"dbtable":"#__core_content","key": "ucm_id","type":"Corecontent","prefix":"JTable","c onfig":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"published","core_alias":"alias","cor e_created_time":"created_time","core_modified_time ":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_ publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}], "special": [{"parent_id":"parent_id","lft":"lft","rgt":"rgt"," level":"level","path":"path","extension":"extensio n","note":"note"}]}','ContentHelperRoute::getCategoryRoute'), (6, 'Contact Category', 'com_contact.category', '{"special":{"dbtable":"#__categories","key":"id", "type":"Category","prefix":"JTable","config":"arra y()"},"common":{"dbtable":"#__core_content","key": "ucm_id","type":"Corecontent","prefix":"JTable","c onfig":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"published","core_alias":"alias","cor e_created_time":"created_time","core_modified_time ":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_ publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}], "special": [{"parent_id":"parent_id","lft":"lft","rgt":"rgt"," level":"level","path":"path","extension":"extensio n","note":"note"}]}','ContactHelperRoute::getCategoryRoute'), (7, 'Newsfeeds Category', 'com_newsfeeds.category', '{"special":{"dbtable":"#__categories","key":"id", "type":"Category","prefix":"JTable","config":"arra y()"},"common":{"dbtable":"#__core_content","key": "ucm_id","type":"Corecontent","prefix":"JTable","c onfig":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"published","core_alias":"alias","cor e_created_time":"created_time","core_modified_time ":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_ publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}], "special": [{"parent_id":"parent_id","lft":"lft","rgt":"rgt"," level":"level","path":"path","extension":"extensio n","note":"note"}]}','NewsfeedsHelperRoute::getCategoryRoute'), (8, 'Tag', 'com_tags.tag', '{"special":{"dbtable":"#__tags","key":"tag_id","t ype":"Tag","prefix":"TagsTable","config":"array()" },"common":{"dbtable":"#__core_content","key":"ucm _id","type":"Corecontent","prefix":"JTable","confi g":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"published","core_alias":"alias","cor e_created_time":"created_time","core_modified_time ":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_ publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}], "special": [{"parent_id":"parent_id","lft":"lft","rgt":"rgt"," level":"level","path":"path"}]}','TagsHelperRoute::getTagRoute');
Après avoir installé une copie de mon site en local (wamp) et supprimé absolument toutes mes extension (template, composant...), j'ai un message d'erreur à la fin de la mise à jour (voir ci-dessous). Le site et ma base de donnée sont pourtant bien à jour (2.5.28). Après cette erreur l'administration du site est inutilisable car chaque lien mène vers une page blanche Quelqu'un aurait une idée ?
1062 - Une erreur s'est produite
Duplicate entry '1' for key 'PRIMARY' SQL=-- -- Dumping data for table `gftg0_content_types` -- INSERT INTO `gftg0_content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`,`router`) VALUES (1, 'Article', 'com_content.article', '{"special":{"dbtable":"#__content","key":"id","ty pe":"Content","prefix":"JTable","config":"array()" },"common":{"dbtable":"#__core_content","key":"ucm _id","type":"Corecontent","prefix":"JTable","confi g":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"state","core_alias":"alias","core_cr eated_time":"created","core_modified_time":"modifi ed","core_body":"introtext", "core_hits":"hits","core_publish_up":"publish_up", "core_publish_down":"publish_down","core_access":" access", "core_params":"attribs", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"asset_id"}], "special": [{"fulltext":"fulltext"}]}','ContentHelperRoute::getArticleRoute'), (2, 'Contact', 'com_contact.contact', '{"special":{"dbtable":"#__contact_details","key": "id","type":"Contact","prefix":"ContactTable","con fig":"array()"},"common":{"dbtable":"#__core_conte nt","key":"ucm_id","type":"Corecontent","prefix":" JTable","config":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"name"," core_state":"published","core_alias":"alias","core _created_time":"created","core_modified_time":"mod ified","core_body":"address", "core_hits":"hits","core_publish_up":"publish_up", "core_publish_down":"publish_down","core_access":" access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"image", "core_urls":"webpage", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}], "special": [{"con_position":"con_position","suburb":"suburb"," state":"state","country":"country","postcode":"pos tcode","telephone":"telephone","fax":"fax","misc": "misc","email_to":"email_to","default_con":"defaul t_con","user_id":"user_id","mobile":"mobile","sort name1":"sortname1","sortname2":"sortname2","sortna me3":"sortname3"}]}','ContactHelperRoute::getContactRoute'), (3, 'Newsfeed', 'com_newsfeeds.newsfeed', '{"special":{"dbtable":"#__newsfeeds","key":"id"," type":"Newsfeed","prefix":"NewsfeedsTable","config ":"array()"},"common":{"dbtable":"#__core_content" ,"key":"ucm_id","type":"Corecontent","prefix":"JTa ble","config":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"name"," core_state":"published","core_alias":"alias","core _created_time":"created","core_modified_time":"mod ified","core_body":"description", "core_hits":"hits","core_publish_up":"publish_up", "core_publish_down":"publish_down","core_access":" access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}], "special": [{"numarticles":"numarticles","cache_time":"cache_t ime","rtl":"rtl"}]}','NewsfeedsHelperRoute::getNewsfeedRoute'), (4, 'User', 'com_users.user', '{"special":{"dbtable":"#__users","key":"id","type ":"User","prefix":"JTable","config":"array()"},"co mmon":{"dbtable":"#__core_content","key":"ucm_id", "type":"Corecontent","prefix":"JTable","config":"a rray()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"name"," core_state":"null","core_alias":"username","core_c reated_time":"registerdate","core_modified_time":" lastvisitDate","core_body":"null", "core_hits":"null","core_publish_up":"null","core_ publish_down":"null","access":"null", "core_params":"params", "core_featured":"null", "core_metadata":"null", "core_language":"null", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"null", "core_metakey":"null", "core_metadesc":"null", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}], "special": [{}]}','UsersHelperRoute::getUserRoute'), (5, 'Article Category', 'com_content.category', '{"special":{"dbtable":"#__categories","key":"id", "type":"Category","prefix":"JTable","config":"arra y()"},"common":{"dbtable":"#__core_content","key": "ucm_id","type":"Corecontent","prefix":"JTable","c onfig":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"published","core_alias":"alias","cor e_created_time":"created_time","core_modified_time ":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_ publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}], "special": [{"parent_id":"parent_id","lft":"lft","rgt":"rgt"," level":"level","path":"path","extension":"extensio n","note":"note"}]}','ContentHelperRoute::getCategoryRoute'), (6, 'Contact Category', 'com_contact.category', '{"special":{"dbtable":"#__categories","key":"id", "type":"Category","prefix":"JTable","config":"arra y()"},"common":{"dbtable":"#__core_content","key": "ucm_id","type":"Corecontent","prefix":"JTable","c onfig":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"published","core_alias":"alias","cor e_created_time":"created_time","core_modified_time ":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_ publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}], "special": [{"parent_id":"parent_id","lft":"lft","rgt":"rgt"," level":"level","path":"path","extension":"extensio n","note":"note"}]}','ContactHelperRoute::getCategoryRoute'), (7, 'Newsfeeds Category', 'com_newsfeeds.category', '{"special":{"dbtable":"#__categories","key":"id", "type":"Category","prefix":"JTable","config":"arra y()"},"common":{"dbtable":"#__core_content","key": "ucm_id","type":"Corecontent","prefix":"JTable","c onfig":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"published","core_alias":"alias","cor e_created_time":"created_time","core_modified_time ":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_ publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}], "special": [{"parent_id":"parent_id","lft":"lft","rgt":"rgt"," level":"level","path":"path","extension":"extensio n","note":"note"}]}','NewsfeedsHelperRoute::getCategoryRoute'), (8, 'Tag', 'com_tags.tag', '{"special":{"dbtable":"#__tags","key":"tag_id","t ype":"Tag","prefix":"TagsTable","config":"array()" },"common":{"dbtable":"#__core_content","key":"ucm _id","type":"Corecontent","prefix":"JTable","confi g":"array()"}}', '', '{"common":[{"core_content_item_id":"id","core_title":"title", "core_state":"published","core_alias":"alias","cor e_created_time":"created_time","core_modified_time ":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_ publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}], "special": [{"parent_id":"parent_id","lft":"lft","rgt":"rgt"," level":"level","path":"path"}]}','TagsHelperRoute::getTagRoute');
Commentaire